Name |
Code |
Parent Table |
Child Table |
Foreign Key Columns |
Parent Role |
Child Role |
PerfServiceID |
|
|
||||
InfectionID |
|
|
||||
EventID |
|
|
||||
BodyPartID |
|
|
||||
ServID |
|
|
||||
PerfServiceID |
|
|
||||
InfectionClassID |
|
|
||||
MaterialID |
|
|
||||
InfectionID |
|
|
||||
InfectionEffectID |
|
|
||||
InfectionEffectID |
|
|
||||
InfectionID |
|
|
||||
PreventActionID |
|
|
||||
MicrobeID |
|
|
||||
PreventActionID |
|
|
||||
InfectionID |
|
|
||||
MicrobeID |
|
|
||||
InfectionID |
|
|
||||
InfectionQualificationID |
|
|
||||
InfectionQualificationID |
|
|
||||
RiskGroupID |
|
|
||||
InfectionID |
|
|
||||
RiskGroupID |
|
|
||||
IdentifierTypeID; ExternalValue |
|
|
||||
InfectionID |
|
|
||||
AdditExaminationID |
|
|
||||
InfectionID |
|
|
||||
AdditExaminationID |
|
|
||||
ClinicalSignsID |
|
|
||||
RiskFactorTypeID |
|
|
||||
PreventiveActionID |
|
|
||||
InfectionID |
|
|
||||
PreventiveActionID |
|
|
||||
RiskFactorID |
|
|
||||
PatogenInstanceID |
|
|
||||
RiskFactorID |
|
|
||||
SurgeryID |
|
|
||||
PatogenInstanceID |
|
|
||||
ClinicalSignsID |
|
|
||||
InfectionID |
|
|
||||
RiskFactorID |
|
|
||||
RiskFactorTypeID |
|
|
||||
APSourceHospitalID |
|
|
||||
APClassSourceHospitalID |
|
|
||||
ResourceID |
|
|
||||
UnitID |
|
|
||||
FrequencyID |
|
|
||||
ApplicationWayID |
|
|
||||
AntimicrobialDrugsID |
|
|
||||
PatogenTypeID |
|
|
|
|
|